2016-07-26 - 27720 - Enhancement - COPA Reloading and COPA source split #FinanceControlling
SPECIFICATIONS
27720 - COPA Reloading and COPA source split
Purpose
Need to reload COPA data from SAP & splitting of the COPA source into historic(until 2014) and current(2016 and 2015).
Admin Info
Purpose
|
Need to reload COPA data from SAP & splitting of the COPA source into historic(until 2014) and current (2016 and 2015).
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
07/26/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
COPA Infocube
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
00
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
00
|
|
TOTAL
|
16
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Meeting with Mark Harris on 07/04/2016:
Here are the meeting notes regarding the issues:
1. Need to add the PO type and SO type into COPA source.
2. Need to add the PO type and SO type into Open Order source.
3. Need to enhance the multiproviders and BEx queries based on the COPA and Open Order sources with these two fields.
4. Need to split the COPA source into historical cube(<=2014) and current cube(>=2015) to improve the performance.
In Scope:
COPA Infocube.
Out of Scope:
Other Sources
Solution Summary
1. Adding the PO type and SO type into COPA source - PO type is already existing but SO type need to be added which requires enhancement of COPA datasource along with downtime for reloading the COPA source after the changes. Business has not confirmed the downtime to effect these changes.
2. Adding the PO type and SO type into Open Order source - These fields are available in the Sales order DSO as well as Open order cube.
3. Enhancement to the multiproviders and BEx queries based on Open Order sources is completed based on the available fields.
4. Splitting the COPA source into historical cube(<=2014) and current cube(>=2015) to improve the performance has not be undertaken due to HANA upgrade project which will improve performance.
Test Plan
Test ID
|
Test Case
|
Expected Results
|
1
|
Check if PO type and SO type are available in the Open Order source.
|
Both PO type and SO type are available in the Open Order source.
|
2
|
Check if PO type is available in the COPA source.
|
PO type is available in the COPA source.
|
3
|
Check if the available fields are added to the Multiproviders and BEx queries.
|
All the available fields are added to the Multiproviders and BEx queries.
|
Solution Details
1. Adding the PO type and SO type into COPA source - PO type is already existing but SO type need to be added which requires enhancement of COPA datasource along with downtime for reloading the COPA source after the changes. Business has not confirmed the downtime to effect these changes.
2. Adding the PO type and SO type into Open Order source - These fields are available in the Sales order DSO as well as Open order cube.
3. Enhancement to the multiproviders and BEx queries based on Open Order sources is completed based on the available fields.
4. Splitting the COPA source into historical cube(<=2014) and current cube(>=2015) to improve the performance has not be undertaken due to HANA upgrade project which will improve performance.
Issues
1. Business has not confirmed the downtime for BPP for moving the enhancement changes, hence it is on hold.
2. Since the enhancement has not been done, there is no Release Note or transport request created for this issue.
3. COPA infocube split is not undertaken since HANA project was approved that will improve the performance.